You have ARCHIVED the BSIS table (because of old data etc) and now this BSIS
table has "holes" in physical structure and it's quite a large table.
Here are the steps to reorg. a single object:
1. Take a backup of your Oracle database.
2. Shutdown SAP
3. Start Oracle Database with Rollback Segment PSAPROLLBIG (all other smaller
segments not started). Remember, the size of PSAPROLLBIG should be equal or
larger than your BSIS table.
4. Ensure sapreorg directory has enough space for taking BSIS Oracle Export
dump. The Oracle Export utility compresses the file to some extent.
5. Fire your SAPDBA from Unix level.
6. Go into SAPDBA "reorganisation" menu.
7. Select "Reorganize Single Table / Index"
8. Give BSIS as table name.
9. Start.
10. Don't Forget, first upgrade your SAPDBA tools first from OSS/SAPNet.
These include: 1. sapdba 2. brtools 3. brarchive 4. brbackup 5. brrestore 6.
brconnect.
